CASH FLOW STATEMENT
umbrella clinic lp
Sources of Funds
Cash from Sales Account Receivables
Start-up
25,520.33 15,452.33
August
32,125.22 13,455.22
September
38,500.00 15,412.00
October
35,412.78 18,987.25
November
45,125.33 22,451.22
December
55,458.33 36,000.00
January
62,458.33 44,518.33
February
70,125.22 45,250.00
March
69,540.33 47,852.33
April
65,125.00 45,369.00
May
60,258.12 44,698.33
June
59,698.12 45,789.36
July
60,540.33 42,589.36
Total
$679,887.44 $437,824.73
Owner's Investment line of credit
Total Cash In
0.00 10,000.00
50,972.66
0.00 8,800.00
54,380.44
0.00 7,600.00
61,512.00
0.00 6,400.00
60,800.03
0.00 5,200.00
72,776.55
0.00 4,000.00
95,458.33
0.00 2,800.00
109,776.66
0.00 1,600.00
116,975.22
0.00 400.00
117,792.66
0.00 0.00
110,494.00
0.00 0.00
104,956.45
0.00 0.00
105,487.48
0.00 0.00 $46,800.00 $0.00
103,129.69 $1,164,512.17
Cash Outflows
Purchase of Equipment Repairs and Maintenance Computer Software Inventory Materials (supplies, tools) Business License(s) Advertising line of credit payment Fuel Bank Fees Telephone Transportation Internet Insurance
Start-up
12,540.33 1,252.60 500.55 1,202.11 1,255.89 65.00 2,504.30 1,200.00 0.00 25.50 65.33 0.00 55.12 365.00
August
11,542.02 521.33 251.60 547.89 128.36 65.00 3,250.25 1,200.00 0.00 25.50 87.25 0.00 66.22 365.00
September
7,450.12 200.36 100.00 251.56 55.68 65.00 2,350.00 1,200.00 0.00 25.50 112.22 0.00 89.26 365.00
October
4,500.00 120.56 58.99 120.00 78.66 65.00 1,250.00 1,200.00 0.00 25.50 389.33 0.00 112.33 365.00
October
2,200.33 55.45 12.33 450.32 125.00 65.00 2,054.65 1,200.00 0.00 25.50 74.65 0.00 78.63 365.00
December
120.00 22.12 0.00 123.63 514.33 65.00 1,200.00 1,200.00 0.00 25.50 69.55 0.00 88.98 365.00
January
521.22 54.12 42.33 100.00 210.33 65.00 2,005.20 1,200.00 0.00 25.50 54.12 0.00 98.55 365.00
February
0.00 0.00 20.00 55.60 365.00 65.00 1,200.33 1,200.00 0.00 25.50 73.65 0.00 112.36 365.00
March
425.33 109.00 23.22 45.22 859.66 65.00 1,000.33 400.00 0.00 25.50 89.36 0.00 69.66 365.00
April
400.36 66.99 12.36 555.12 120.36 65.00 2,500.00 0.00 0.00 25.50 98.36 0.00 78.36 365.00
May
255.00 0.00 0.00 236.45 66.87 65.00 890.36 0.00 0.00 25.50 59.00 0.00 102.36 365.00
June
0.00 120.55 19.99 102.54 55.00 0.00 1,256.00 0.00 0.00 25.50 89.33 0.00 89.22 365.00
July
233.66 220.33 22.59 250.00 1,200.00 65.00 2,000.00 0.00 0.00 25.50 125.33 0.00 99.25 365.00
Total
$40,188.37 $2,743.41 $1,063.96 $4,040.44 $5,035.14 $780.00 $23,461.42 $10,000.00 $0.00 $331.50 $1,387.48 $0.00 $1,140.30 $4,745.00 $0.00 $0.00 $0.00
Total Cash Out
21,031.73
18,050.42
12,264.70
8,285.37
6,706.86
3,794.11
4,741.37
3,482.44
3,477.28
4,287.41
2,065.54
2,123.13
4,606.66
$94,917.02
Opening Balance Net Flow Closing balance
50,972.66 29,940.93 29,940.93
29,940.93 36,330.02 66,270.95
66,270.95 49,247.31 115,518.26
115,518.26 52,514.66 168,032.92
168,032.92 66,069.69 234,102.61
234,102.61 91,664.22 325,766.83
325,766.83 105,035.29 430,802.11
430,802.11 113,492.78 544,294.89
544,294.89 114,315.38 658,610.27
658,610.27 106,206.59 764,816.86
764,816.86 102,890.91 867,707.77
867,707.77 103,364.35
971,072.12 98,523.03
1,069,595.15
971,072.12 1,069,595.15
Assumptions